Returns or sets the major tick-mark type for the specified axis. Read/write ChartTickMarkEnum.
ChartTickMarkEnum can be one of these ChartTickMarkEnum constants. |
chTickMarkAutomatic |
chTickMarkCross |
chTickMarkInside |
chTickMarkNone |
chTickMarkOutside |
expression.MajorTickMarks
expression Required. An expression that returns a ChAxis object.
This example turns off major tick marks on the specified axis.
Sub DisableMajorTickMarks()
Dim chConstants
Set chConstants = ChartSpace1.Constants
ChartSpace1.Charts(0).Axes(chConstants.chAxisPositionLeft).MajorTickMarks _
= chConstants.chTickMarkNone
End Sub